﻿-- ================================START====================================
-- Template generated from		FRAMEWORKIVY CODE GENERATOR
-- Generator Version:			<1.0.0.0>
-- Template Creation Time:		<Thursday, 26 May, 2016   12:32:16 AM>
-- Template Modification Time:	<Monday, 23 May, 2016   11:22:57 PM>
-- Code Generation Time:		<Thursday, 26 May, 2016   12:52:16 AM>
-- Workstation ID:				<PRAVESH>
-- Current system User ID:		<pravesh kr>
-- Entity/Table Name:			<UserOrganizationRole>
-- Description:					<SQL Server Stored Procedure For GetbyPrimaryKey>
-- Template File:				<IvyGodeGenDefaultTemplate V1.1.xml>

-- Please modify the generated code as per requirement.
-- This code generator is just to speed up the stereo type codes
-- Complex logic needs to be modified manually.

-- This block of comments will not be included in
-- the definition of the procedure.
-- =========================================================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Ivy_UserManagement_UserOrganizationRole_GetAllByUserKeyOrganizationKey')
	BEGIN
		DROP  Procedure  [Ivy_UserManagement_UserOrganizationRole_GetAllByUserKeyOrganizationKey]
	END
GO

CREATE PROCEDURE [Ivy_UserManagement_UserOrganizationRole_GetAllByUserKeyOrganizationKey]
-- =========================================================================
-- Created by				FRAMEWORKIVY CODE GENERATOR
-- Generator Version:		<1.0.0.0>
-- Template version used:   <1.0>
-- Template created by:		<Mrinmoy Das>
-- Code generated by:		<pravesh kr>
-- Code generation Time:	<Thursday, 26 May, 2016   12:52:16 AM>
-- Entity/Table Name:		<UserOrganizationRole>
-- Description:             <SQL Server Stored Procedure For GetbyPrimaryKey>
-- =========================================================================

-- Add the parameters for the stored procedure here

	(
				@UserKey int = NULL,
				@UserOrganizationKey int = NULL
	) 
AS 
BEGIN 
	-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements. 
	SET NOCOUNT OFF; 

    SELECT 
			[RoleKey],
			[RoleCode],
			[RoleName]

	FROM	[Sys_RoleMaster]
					 
	WHERE
		(	[Sys_RoleMaster].[RoleKey] NOT IN  
			(	SELECT 
						[UserRoleKey]
				FROM	[UserOrganizationRole]
				WHERE     
					(	[UserKey] = @UserKey AND 
						[UserOrganizationKey] = @UserOrganizationKey
					)
			)
		)
END 
GO 

-- =================================END=====================================

